CREATE EXTERNAL TABLE jms_dm.dm_not_out_scan_8hour_detail_dt(
  waybill_no string COMMENT '单号',
  scan_site_code string COMMENT '扫描网点code',
  scan_site string COMMENT '扫描网点name',
  agent_code string COMMENT '代理区code',
  agent_name string COMMENT '代理区name',
  virt_code string COMMENT '虚拟代理区code',
  virt_name string COMMENT '虚拟代理区name',
  store_code string COMMENT '门店编码',
  store_name string COMMENT '门店名称',
  customer_service_telephone string COMMENT '网点客服电话',
  scan_time_in timestamp COMMENT '扫描时间',
  scan_time_out timestamp COMMENT '出库扫描时间',
  is_out_scan tinyint COMMENT '是否出库扫描,1未出库',
  in_diff_date int COMMENT '已入库天数',
  date_time date COMMENT '查询时间',
  scan_user string COMMENT '扫描员',
  scan_user_code string COMMENT '扫描员code')
COMMENT '入库未出库短信发送——明细'
PARTITIONED BY (dt string COMMENT '日期分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_not_out_scan_8hour_detail_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);